---
name: "pg_autoctl show standby-names"
section: "1"
platform: "linux"
package: "pg-auto-failover-cli"
version: "2.2-2"
release: "Debian 13 (Trixie)"
platforms: ["linux"]
url: "https://new.carta.tech/pg_autoctl show standby-names"
---

# pg\_autoctl show standby-names(1)

pg\_autoctl show standby-names pg\_autoctl show standby-names - Prints synchronous\_standby\_names for a given group

## NAME

pg\_autoctl show standby-names - pg\_autoctl show standby-names

pg\_autoctl show standby-names - Prints synchronous\_standby\_names for a given group

## SYNOPSIS

This command prints the current value for synchronous\_standby\_names for the primary Postgres server of the target group (default **0**) in the target formation (default **default**), as computed by the monitor:

```
usage: pg_autoctl show standby-names  [ --pgdata ] --formation --group
  --pgdata      path to data directory
  --monitor     pg_auto_failover Monitor Postgres URL
  --formation   formation to query, defaults to 'default'
  --group       group to query formation, defaults to all
  --json        output data in the JSON format
```

## OPTIONS

- **--pgdata**

  Location of the Postgres node being managed locally. Defaults to the environment variable **PGDATA**. Use **--monitor** to connect to a monitor from anywhere, rather than the monitor URI used by a local Postgres node managed with **pg\_autoctl**.

- **--monitor**

  Postgres URI used to connect to the monitor. Must use the **autoctl\_node** username and target the **pg\_auto\_failover** database name. It is possible to show the Postgres URI from the monitor node using the command *pg\_autoctl show uri*.

  Defaults to the value of the environment variable **PG\_AUTOCTL\_MONITOR**.

- **--formation**

  Show the current **synchronous\_standby\_names** value for the given formation. Defaults to the **default** formation.

- **--group**

  Show the current **synchronous\_standby\_names** value for the given group in the given formation. Defaults to group **0**.

- **--json**

  Output a JSON formatted data instead of a table formatted list.

## ENVIRONMENT

PGDATA

Postgres directory location. Can be used instead of the **--pgdata** option.

PG\_AUTOCTL\_MONITOR

Postgres URI to connect to the monitor node, can be used instead of the **--monitor** option.

XDG\_CONFIG\_HOME

The pg\_autoctl command stores its configuration files in the standard place XDG\_CONFIG\_HOME. See the *XDG Base Directory Specification*.

XDG\_DATA\_HOME

The pg\_autoctl command stores its internal states files in the standard place XDG\_DATA\_HOME, which defaults to **~/.local/share**. See the *XDG* *Base Directory Specification*.

## EXAMPLES

```
$ pg_autoctl show standby-names
'ANY 1 (pgautofailover_standby_2, pgautofailover_standby_3)'
$ pg_autoctl show standby-names --json
{
    "formation": "default",
    "group": 0,
    "synchronous_standby_names": "ANY 1 (pgautofailover_standby_2, pgautofailover_standby_3)"
}
```

## AUTHOR

Microsoft

## COPYRIGHT

Copyright (c) Microsoft Corporation. All rights reserved.